I have a table that definitely exists in the logged-in user's schema (therefore I own the table) and is not a view/synonym/anything wacky. I can select from it, but when I try and either insert, update or delete from this table, I get . ORA-00942: table or view does not exist. I'm completely baffled.
Share, comment, bookmark or report
And for every table generation is successful and commit made. But when I try to use it anyhow on that account, for example: But when I try to use it anyhow on that account, for example: select * from CLIENTS;
Share, comment, bookmark or report
I have application / service which connects to Oracle database (11g) which shows me"ORA-00942: table or view does not exist" in its log file without any indication of particular table/view with which it has problem. And there is no way on app side to increase log details to include this data.
Share, comment, bookmark or report
ORA-00942 table or view does not exist. Cause: The table or view specified does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. If you are trying to access tables or views of another schema then you might not have required privileges to do it. Action: You can-check the spelling of the ...
Share, comment, bookmark or report
This could be a possible duplicate of ORA-00942: table or view does not exist- Can it be solved by granting privileges to user?. – John K. N. Commented Sep 1, 2020 at 10:00
Share, comment, bookmark or report
If you don't want to prefix the table name with the schema, create a synonym in the teacher1 schema: create synonym teacher1.instructors for sys.instructors; Then teacher1 can access the table from the SYS schema without fully qualifying it.
Share, comment, bookmark or report
If I try to create a materialized view using the synonym however, it fails: SQL> create materialized view REMOTE_MV build immediate refresh complete next sysdate+1 with ROWID as select * from REMOTE_VIEW; ORA-00942: table or view does not exist Creating the materialized view without the synonym succeeds:
Share, comment, bookmark or report
ORA-00942 table or view does not exist means either the table A.TABAAA exists but you have no privileges on it or the table does not exist at all. The view all_tables doe not show you all tables of the database but only the tables that you can access. Generally you cannot check if a table does not exist at all nor can you grant yourself ...
Share, comment, bookmark or report
I have been tasked with allowing developers to kill their own sessions in the Development database. I've written a procedure, but for some reason I'm getting PL/SQL: ORA-00942: table or view does not
Share, comment, bookmark or report
When I using this statement in Oracle to view the values of a table_name, I got this: SELECT * FROM MEMBER and I got this result. Table does not exist. ORA-00942: table or view does not exist This means the table values can not be display with SELECT statement?
Share, comment, bookmark or report
Comments